SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This 4 bedroom, 3.5 bath contemporary is beautifully situated on a corner 1.97+/- acre lot in the village of Etna in Hanover. The main floor features an open cherry kitchen with granite counters, lots of storage and light filled dining area that leads to a brand new deck. The living room with it's cozy woodstove and soaring catherdral ceilings is perfect for gathering and entertaining and the primary suite with a walk through closet and a full bath is nicely nestled on the backside of the home. Upstairs features 3 bedrooms, a full bath and a loft space overlooking the living room. In the walkout basement you have a mudroom off the 2 car garage, big family room, 3/4 bath, laundry and a bonus room for exercise equipment and all your outdoor gear. Love to bike and hike?! Numerous trails within super close proximity - Trescott trails, AT and more! A great house in a great location! Delayed showings start on Saturday, March 29th at the Open House from 11:00-1:00.
Description:Just 15 minutes from DHMC, Dartmouth College, AND 12A, this thoughtfully updated ranch offers the peace and quiet of a rural setting within a wonderful neighborhood. A large kitchen (with Crown Point cabinetry, marble countertops, and newer appliances), spacious living areas, three bedrooms, and updated 3/4 primary and full hall baths complete the main floor. Downstairs you'll find another bedroom, family room, and office (all with new carpet), a full bath, laundry/workshop, and storage galore. New paint, garage door system, wood shed, Trex deck, fenced yard, mature flower gardens, and raised vegetable gardens enhance the exterior. Energy efficiency is a priority: windows installed since 2017 are Anderson 400 Low-E, a fully-owned 10-megawatt solar panel system, an electric heat pump hot water heater for domestic hot water, and a Level-2 CCS EV charger. Too many updates to name here - a full list available upon request.
Description:Sited on a southeast-facing ridge in the hills of Plainfield, this extraordinary estate seamlessly blends elegance, solitude, and natural beauty. The private 103 acres of pristine woodlands with multiple ponds, meandering hiking and riding trails, and views of local hills and distant mountains, offers the ultimate retreat while being just minutes from Dartmouth College, DHMC, I-89, and I-91. Its location provides both tranquility and convenient access to the best of the Upper Valley, Boston, and beyond. The residence is a unique fusion of Tuscan-inspired design, Italian elegance, and traditional New England craftsmanship. Recently renovated with meticulous attention to detail, the home features a sun-drenched, flexible floor plan with five spacious bedrooms, multiple additional spaces to use as you see fit, and a guest wing. The redesigned eat-in kitchen and breakfast nook showcase modern updates, while radiant heat, wood, and pellet stoves ensure cozy warmth. Notable features such as the observation tower provide unique spaces to relax, take in the spectacular views, and stargaze. The property is designed for both leisure and function and includes a 2-bay attached garage, 1-bay under, 3-bay detached barn, and more. There's ample space for your hobbies and all the gear. Whether exploring the trails, enjoying the ponds, or hosting in the expansive living spaces, this retreat delivers a lifestyle of unmatched serenity, privacy, luxury, and sophistication.
Description:Marvellous contemporary cape in move-in condition with fabulous gleaming hardwood floors throughout the main level. Open first floor has spacious kitchen, dining room, living room, mudroom, office and 1/2 bath/laundry. Second floor has 3 bedrooms, 2 full bathrooms. Separate suite, accessed from mudroom has large living room or home office, bedroom, and 3/4 bath. This residential neighborhood location makes for quick and easy commuting to the medical center, without driving through Hanover, or to the College. A great one! Showings start at Open House Saturday, Jan 4, 10am-12 and Sunday, Jan 5, 2-4pm
Description:Completed in 2023, this hilltop passion project is one of a kind. Located on one of the highest points in Grantham, this property has nearly 270 degree views, including nearby peaks like Grantham Mountain and Croydon Mountain, as well as distant peaks like Mt. Kearsarge, Mt. Sunapee, and Mt. Cardigan. Sited on 9.41 acres, this home has privacy on all sides, and is nicely hidden from the street. A solar tracker at the top of the hill powers the entire home for about 9 months out of the year. The home is all electric, utilizing energy efficient heat pumps for both winter heat and summer A/C. The layout of the home is open concept with 22ft+ ceilings in the central living area and views from every room. The main section includes a floor to ceiling fireplace, an expansive dining area, sunroom corner, and a designer kitchen with an oversized island. Off the kitchen is a guest room with vaulted ceilings and custom built barn doors that allow for privacy when needed, and sunlight/views when the room is not in use. The upstairs loft serves as a 3rd bedroom or office, and has an adjacent full bath and large closet. Back on the main floor, the master bedroom faces south toward Mt. Sunapee, with daily sunrises and sunsets visible from each set of windows. The suite includes a large walk-through closet with custom built-ins, and a master bathroom that has an expansive tiled shower and dual vanity. The basement/garage is also heated, and is large enough to fit 3 vehicles and a tractor.